Explanation: Foxhound cannot collect performance statistics if the target server CollectStatistics feature is turned off; i.e., if SELECT PROPERTY ( 'CollectStatistics' ) returns 'No'.

This can happen after the target server is started with the -k option, or after CALL sa_server_option ( 'CollectStatistics', 'NO' ) is executed on the target database. When this happens, Foxhound stops sampling and displays these messages:

-- Foxhound requires target PROPERTY ( CollectStatistics ) = Yes; i.e., do not specify dbsrv -k - sampling stopped -- 
-- Foxhound requires target PROPERTY ( CollectStatistics ) = Yes; i.e., do not specify dbsrv -k - sampling stopped at -- 

You may also see messages like this:

-- Value 18446744073709551615 out of range for destination --
-- Value 18446744073709551615 out of range for destination at --

If this problem was caused by a CALL sa_server_option ( 'CollectStatistics', 'NO' ) on the target database,

- you may be able to fix it with a CALL sa_server_option ( 'CollectStatistics', 'YES' )

- then clicking on Start Sampling on the Foxhound Monitor page.

If this problem was caused by starting the target server with dbsrv -k,

- the CALL might not work; you may see another message Value 18446744073709551615 out of range for destination.

- In that case, try stopping the target server, and then restarting it without the dbsrv -k option.

- After that, you may have to click Start Sampling on the Foxhound Monitor page.